package com.kingzoon.seckill.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;

public class UaMemberInfoExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Integer offset;

    public UaMemberInfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setLimit(Integer limit) {
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return offset;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andExchangeIdIsNull() {
            addCriterion("EXCHANGE_ID is null");
            return (Criteria) this;
        }

        public Criteria andExchangeIdIsNotNull() {
            addCriterion("EXCHANGE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andExchangeIdEqualTo(String value) {
            addCriterion("EXCHANGE_ID =", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdNotEqualTo(String value) {
            addCriterion("EXCHANGE_ID <>", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdGreaterThan(String value) {
            addCriterion("EXCHANGE_ID >", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdGreaterThanOrEqualTo(String value) {
            addCriterion("EXCHANGE_ID >=", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdLessThan(String value) {
            addCriterion("EXCHANGE_ID <", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdLessThanOrEqualTo(String value) {
            addCriterion("EXCHANGE_ID <=", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdLike(String value) {
            addCriterion("EXCHANGE_ID like", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdNotLike(String value) {
            addCriterion("EXCHANGE_ID not like", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdIn(List<String> values) {
            addCriterion("EXCHANGE_ID in", values, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdNotIn(List<String> values) {
            addCriterion("EXCHANGE_ID not in", values, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdBetween(String value1, String value2) {
            addCriterion("EXCHANGE_ID between", value1, value2, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdNotBetween(String value1, String value2) {
            addCriterion("EXCHANGE_ID not between", value1, value2, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdIsNull() {
            addCriterion("DISTRIBUTOR_ID is null");
            return (Criteria) this;
        }

        public Criteria andDistributorIdIsNotNull() {
            addCriterion("DISTRIBUTOR_ID is not null");
            return (Criteria) this;
        }

        public Criteria andDistributorIdEqualTo(String value) {
            addCriterion("DISTRIBUTOR_ID =", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdNotEqualTo(String value) {
            addCriterion("DISTRIBUTOR_ID <>", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdGreaterThan(String value) {
            addCriterion("DISTRIBUTOR_ID >", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdGreaterThanOrEqualTo(String value) {
            addCriterion("DISTRIBUTOR_ID >=", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdLessThan(String value) {
            addCriterion("DISTRIBUTOR_ID <", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdLessThanOrEqualTo(String value) {
            addCriterion("DISTRIBUTOR_ID <=", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdLike(String value) {
            addCriterion("DISTRIBUTOR_ID like", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdNotLike(String value) {
            addCriterion("DISTRIBUTOR_ID not like", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdIn(List<String> values) {
            addCriterion("DISTRIBUTOR_ID in", values, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdNotIn(List<String> values) {
            addCriterion("DISTRIBUTOR_ID not in", values, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdBetween(String value1, String value2) {
            addCriterion("DISTRIBUTOR_ID between", value1, value2, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdNotBetween(String value1, String value2) {
            addCriterion("DISTRIBUTOR_ID not between", value1, value2, "distributorId");
            return (Criteria) this;
        }

        public Criteria andMemberIdIsNull() {
            addCriterion("MEMBER_ID is null");
            return (Criteria) this;
        }

        public Criteria andMemberIdIsNotNull() {
            addCriterion("MEMBER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andMemberIdEqualTo(String value) {
            addCriterion("MEMBER_ID =", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotEqualTo(String value) {
            addCriterion("MEMBER_ID <>", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdGreaterThan(String value) {
            addCriterion("MEMBER_ID >", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdGreaterThanOrEqualTo(String value) {
            addCriterion("MEMBER_ID >=", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLessThan(String value) {
            addCriterion("MEMBER_ID <", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLessThanOrEqualTo(String value) {
            addCriterion("MEMBER_ID <=", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLike(String value) {
            addCriterion("MEMBER_ID like", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotLike(String value) {
            addCriterion("MEMBER_ID not like", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdIn(List<String> values) {
            addCriterion("MEMBER_ID in", values, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotIn(List<String> values) {
            addCriterion("MEMBER_ID not in", values, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdBetween(String value1, String value2) {
            addCriterion("MEMBER_ID between", value1, value2, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotBetween(String value1, String value2) {
            addCriterion("MEMBER_ID not between", value1, value2, "memberId");
            return (Criteria) this;
        }

        public Criteria andLoginNameIsNull() {
            addCriterion("LOGIN_NAME is null");
            return (Criteria) this;
        }

        public Criteria andLoginNameIsNotNull() {
            addCriterion("LOGIN_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andLoginNameEqualTo(String value) {
            addCriterion("LOGIN_NAME =", value, "loginName");
            return (Criteria) this;
        }

        public Criteria andLoginNameNotEqualTo(String value) {
            addCriterion("LOGIN_NAME <>", value, "loginName");
            return (Criteria) this;
        }

        public Criteria andLoginNameGreaterThan(String value) {
            addCriterion("LOGIN_NAME >", value, "loginName");
            return (Criteria) this;
        }

        public Criteria andLoginNameGreaterThanOrEqualTo(String value) {
            addCriterion("LOGIN_NAME >=", value, "loginName");
            return (Criteria) this;
        }

        public Criteria andLoginNameLessThan(String value) {
            addCriterion("LOGIN_NAME <", value, "loginName");
            return (Criteria) this;
        }

        public Criteria andLoginNameLessThanOrEqualTo(String value) {
            addCriterion("LOGIN_NAME <=", value, "loginName");
            return (Criteria) this;
        }

        public Criteria andLoginNameLike(String value) {
            addCriterion("LOGIN_NAME like", value, "loginName");
            return (Criteria) this;
        }

        public Criteria andLoginNameNotLike(String value) {
            addCriterion("LOGIN_NAME not like", value, "loginName");
            return (Criteria) this;
        }

        public Criteria andLoginNameIn(List<String> values) {
            addCriterion("LOGIN_NAME in", values, "loginName");
            return (Criteria) this;
        }

        public Criteria andLoginNameNotIn(List<String> values) {
            addCriterion("LOGIN_NAME not in", values, "loginName");
            return (Criteria) this;
        }

        public Criteria andLoginNameBetween(String value1, String value2) {
            addCriterion("LOGIN_NAME between", value1, value2, "loginName");
            return (Criteria) this;
        }

        public Criteria andLoginNameNotBetween(String value1, String value2) {
            addCriterion("LOGIN_NAME not between", value1, value2, "loginName");
            return (Criteria) this;
        }

        public Criteria andLoginPwdIsNull() {
            addCriterion("LOGIN_PWD is null");
            return (Criteria) this;
        }

        public Criteria andLoginPwdIsNotNull() {
            addCriterion("LOGIN_PWD is not null");
            return (Criteria) this;
        }

        public Criteria andLoginPwdEqualTo(String value) {
            addCriterion("LOGIN_PWD =", value, "loginPwd");
            return (Criteria) this;
        }

        public Criteria andLoginPwdNotEqualTo(String value) {
            addCriterion("LOGIN_PWD <>", value, "loginPwd");
            return (Criteria) this;
        }

        public Criteria andLoginPwdGreaterThan(String value) {
            addCriterion("LOGIN_PWD >", value, "loginPwd");
            return (Criteria) this;
        }

        public Criteria andLoginPwdGreaterThanOrEqualTo(String value) {
            addCriterion("LOGIN_PWD >=", value, "loginPwd");
            return (Criteria) this;
        }

        public Criteria andLoginPwdLessThan(String value) {
            addCriterion("LOGIN_PWD <", value, "loginPwd");
            return (Criteria) this;
        }

        public Criteria andLoginPwdLessThanOrEqualTo(String value) {
            addCriterion("LOGIN_PWD <=", value, "loginPwd");
            return (Criteria) this;
        }

        public Criteria andLoginPwdLike(String value) {
            addCriterion("LOGIN_PWD like", value, "loginPwd");
            return (Criteria) this;
        }

        public Criteria andLoginPwdNotLike(String value) {
            addCriterion("LOGIN_PWD not like", value, "loginPwd");
            return (Criteria) this;
        }

        public Criteria andLoginPwdIn(List<String> values) {
            addCriterion("LOGIN_PWD in", values, "loginPwd");
            return (Criteria) this;
        }

        public Criteria andLoginPwdNotIn(List<String> values) {
            addCriterion("LOGIN_PWD not in", values, "loginPwd");
            return (Criteria) this;
        }

        public Criteria andLoginPwdBetween(String value1, String value2) {
            addCriterion("LOGIN_PWD between", value1, value2, "loginPwd");
            return (Criteria) this;
        }

        public Criteria andLoginPwdNotBetween(String value1, String value2) {
            addCriterion("LOGIN_PWD not between", value1, value2, "loginPwd");
            return (Criteria) this;
        }

        public Criteria andNicknameIsNull() {
            addCriterion("NICKNAME is null");
            return (Criteria) this;
        }

        public Criteria andNicknameIsNotNull() {
            addCriterion("NICKNAME is not null");
            return (Criteria) this;
        }

        public Criteria andNicknameEqualTo(String value) {
            addCriterion("NICKNAME =", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotEqualTo(String value) {
            addCriterion("NICKNAME <>", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameGreaterThan(String value) {
            addCriterion("NICKNAME >", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameGreaterThanOrEqualTo(String value) {
            addCriterion("NICKNAME >=", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLessThan(String value) {
            addCriterion("NICKNAME <", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLessThanOrEqualTo(String value) {
            addCriterion("NICKNAME <=", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLike(String value) {
            addCriterion("NICKNAME like", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotLike(String value) {
            addCriterion("NICKNAME not like", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameIn(List<String> values) {
            addCriterion("NICKNAME in", values, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotIn(List<String> values) {
            addCriterion("NICKNAME not in", values, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameBetween(String value1, String value2) {
            addCriterion("NICKNAME between", value1, value2, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotBetween(String value1, String value2) {
            addCriterion("NICKNAME not between", value1, value2, "nickname");
            return (Criteria) this;
        }

        public Criteria andMemberMobileIsNull() {
            addCriterion("MEMBER_MOBILE is null");
            return (Criteria) this;
        }

        public Criteria andMemberMobileIsNotNull() {
            addCriterion("MEMBER_MOBILE is not null");
            return (Criteria) this;
        }

        public Criteria andMemberMobileEqualTo(String value) {
            addCriterion("MEMBER_MOBILE =", value, "memberMobile");
            return (Criteria) this;
        }

        public Criteria andMemberMobileNotEqualTo(String value) {
            addCriterion("MEMBER_MOBILE <>", value, "memberMobile");
            return (Criteria) this;
        }

        public Criteria andMemberMobileGreaterThan(String value) {
            addCriterion("MEMBER_MOBILE >", value, "memberMobile");
            return (Criteria) this;
        }

        public Criteria andMemberMobileGreaterThanOrEqualTo(String value) {
            addCriterion("MEMBER_MOBILE >=", value, "memberMobile");
            return (Criteria) this;
        }

        public Criteria andMemberMobileLessThan(String value) {
            addCriterion("MEMBER_MOBILE <", value, "memberMobile");
            return (Criteria) this;
        }

        public Criteria andMemberMobileLessThanOrEqualTo(String value) {
            addCriterion("MEMBER_MOBILE <=", value, "memberMobile");
            return (Criteria) this;
        }

        public Criteria andMemberMobileLike(String value) {
            addCriterion("MEMBER_MOBILE like", value, "memberMobile");
            return (Criteria) this;
        }

        public Criteria andMemberMobileNotLike(String value) {
            addCriterion("MEMBER_MOBILE not like", value, "memberMobile");
            return (Criteria) this;
        }

        public Criteria andMemberMobileIn(List<String> values) {
            addCriterion("MEMBER_MOBILE in", values, "memberMobile");
            return (Criteria) this;
        }

        public Criteria andMemberMobileNotIn(List<String> values) {
            addCriterion("MEMBER_MOBILE not in", values, "memberMobile");
            return (Criteria) this;
        }

        public Criteria andMemberMobileBetween(String value1, String value2) {
            addCriterion("MEMBER_MOBILE between", value1, value2, "memberMobile");
            return (Criteria) this;
        }

        public Criteria andMemberMobileNotBetween(String value1, String value2) {
            addCriterion("MEMBER_MOBILE not between", value1, value2, "memberMobile");
            return (Criteria) this;
        }

        public Criteria andMemberHeadIconIsNull() {
            addCriterion("MEMBER_HEAD_ICON is null");
            return (Criteria) this;
        }

        public Criteria andMemberHeadIconIsNotNull() {
            addCriterion("MEMBER_HEAD_ICON is not null");
            return (Criteria) this;
        }

        public Criteria andMemberHeadIconEqualTo(String value) {
            addCriterion("MEMBER_HEAD_ICON =", value, "memberHeadIcon");
            return (Criteria) this;
        }

        public Criteria andMemberHeadIconNotEqualTo(String value) {
            addCriterion("MEMBER_HEAD_ICON <>", value, "memberHeadIcon");
            return (Criteria) this;
        }

        public Criteria andMemberHeadIconGreaterThan(String value) {
            addCriterion("MEMBER_HEAD_ICON >", value, "memberHeadIcon");
            return (Criteria) this;
        }

        public Criteria andMemberHeadIconGreaterThanOrEqualTo(String value) {
            addCriterion("MEMBER_HEAD_ICON >=", value, "memberHeadIcon");
            return (Criteria) this;
        }

        public Criteria andMemberHeadIconLessThan(String value) {
            addCriterion("MEMBER_HEAD_ICON <", value, "memberHeadIcon");
            return (Criteria) this;
        }

        public Criteria andMemberHeadIconLessThanOrEqualTo(String value) {
            addCriterion("MEMBER_HEAD_ICON <=", value, "memberHeadIcon");
            return (Criteria) this;
        }

        public Criteria andMemberHeadIconLike(String value) {
            addCriterion("MEMBER_HEAD_ICON like", value, "memberHeadIcon");
            return (Criteria) this;
        }

        public Criteria andMemberHeadIconNotLike(String value) {
            addCriterion("MEMBER_HEAD_ICON not like", value, "memberHeadIcon");
            return (Criteria) this;
        }

        public Criteria andMemberHeadIconIn(List<String> values) {
            addCriterion("MEMBER_HEAD_ICON in", values, "memberHeadIcon");
            return (Criteria) this;
        }

        public Criteria andMemberHeadIconNotIn(List<String> values) {
            addCriterion("MEMBER_HEAD_ICON not in", values, "memberHeadIcon");
            return (Criteria) this;
        }

        public Criteria andMemberHeadIconBetween(String value1, String value2) {
            addCriterion("MEMBER_HEAD_ICON between", value1, value2, "memberHeadIcon");
            return (Criteria) this;
        }

        public Criteria andMemberHeadIconNotBetween(String value1, String value2) {
            addCriterion("MEMBER_HEAD_ICON not between", value1, value2, "memberHeadIcon");
            return (Criteria) this;
        }

        public Criteria andMemberQqinfoIsNull() {
            addCriterion("MEMBER_QQINFO is null");
            return (Criteria) this;
        }

        public Criteria andMemberQqinfoIsNotNull() {
            addCriterion("MEMBER_QQINFO is not null");
            return (Criteria) this;
        }

        public Criteria andMemberQqinfoEqualTo(String value) {
            addCriterion("MEMBER_QQINFO =", value, "memberQqinfo");
            return (Criteria) this;
        }

        public Criteria andMemberQqinfoNotEqualTo(String value) {
            addCriterion("MEMBER_QQINFO <>", value, "memberQqinfo");
            return (Criteria) this;
        }

        public Criteria andMemberQqinfoGreaterThan(String value) {
            addCriterion("MEMBER_QQINFO >", value, "memberQqinfo");
            return (Criteria) this;
        }

        public Criteria andMemberQqinfoGreaterThanOrEqualTo(String value) {
            addCriterion("MEMBER_QQINFO >=", value, "memberQqinfo");
            return (Criteria) this;
        }

        public Criteria andMemberQqinfoLessThan(String value) {
            addCriterion("MEMBER_QQINFO <", value, "memberQqinfo");
            return (Criteria) this;
        }

        public Criteria andMemberQqinfoLessThanOrEqualTo(String value) {
            addCriterion("MEMBER_QQINFO <=", value, "memberQqinfo");
            return (Criteria) this;
        }

        public Criteria andMemberQqinfoLike(String value) {
            addCriterion("MEMBER_QQINFO like", value, "memberQqinfo");
            return (Criteria) this;
        }

        public Criteria andMemberQqinfoNotLike(String value) {
            addCriterion("MEMBER_QQINFO not like", value, "memberQqinfo");
            return (Criteria) this;
        }

        public Criteria andMemberQqinfoIn(List<String> values) {
            addCriterion("MEMBER_QQINFO in", values, "memberQqinfo");
            return (Criteria) this;
        }

        public Criteria andMemberQqinfoNotIn(List<String> values) {
            addCriterion("MEMBER_QQINFO not in", values, "memberQqinfo");
            return (Criteria) this;
        }

        public Criteria andMemberQqinfoBetween(String value1, String value2) {
            addCriterion("MEMBER_QQINFO between", value1, value2, "memberQqinfo");
            return (Criteria) this;
        }

        public Criteria andMemberQqinfoNotBetween(String value1, String value2) {
            addCriterion("MEMBER_QQINFO not between", value1, value2, "memberQqinfo");
            return (Criteria) this;
        }

        public Criteria andMemberEmailIsNull() {
            addCriterion("MEMBER_EMAIL is null");
            return (Criteria) this;
        }

        public Criteria andMemberEmailIsNotNull() {
            addCriterion("MEMBER_EMAIL is not null");
            return (Criteria) this;
        }

        public Criteria andMemberEmailEqualTo(String value) {
            addCriterion("MEMBER_EMAIL =", value, "memberEmail");
            return (Criteria) this;
        }

        public Criteria andMemberEmailNotEqualTo(String value) {
            addCriterion("MEMBER_EMAIL <>", value, "memberEmail");
            return (Criteria) this;
        }

        public Criteria andMemberEmailGreaterThan(String value) {
            addCriterion("MEMBER_EMAIL >", value, "memberEmail");
            return (Criteria) this;
        }

        public Criteria andMemberEmailGreaterThanOrEqualTo(String value) {
            addCriterion("MEMBER_EMAIL >=", value, "memberEmail");
            return (Criteria) this;
        }

        public Criteria andMemberEmailLessThan(String value) {
            addCriterion("MEMBER_EMAIL <", value, "memberEmail");
            return (Criteria) this;
        }

        public Criteria andMemberEmailLessThanOrEqualTo(String value) {
            addCriterion("MEMBER_EMAIL <=", value, "memberEmail");
            return (Criteria) this;
        }

        public Criteria andMemberEmailLike(String value) {
            addCriterion("MEMBER_EMAIL like", value, "memberEmail");
            return (Criteria) this;
        }

        public Criteria andMemberEmailNotLike(String value) {
            addCriterion("MEMBER_EMAIL not like", value, "memberEmail");
            return (Criteria) this;
        }

        public Criteria andMemberEmailIn(List<String> values) {
            addCriterion("MEMBER_EMAIL in", values, "memberEmail");
            return (Criteria) this;
        }

        public Criteria andMemberEmailNotIn(List<String> values) {
            addCriterion("MEMBER_EMAIL not in", values, "memberEmail");
            return (Criteria) this;
        }

        public Criteria andMemberEmailBetween(String value1, String value2) {
            addCriterion("MEMBER_EMAIL between", value1, value2, "memberEmail");
            return (Criteria) this;
        }

        public Criteria andMemberEmailNotBetween(String value1, String value2) {
            addCriterion("MEMBER_EMAIL not between", value1, value2, "memberEmail");
            return (Criteria) this;
        }

        public Criteria andMemberPointsIsNull() {
            addCriterion("MEMBER_POINTS is null");
            return (Criteria) this;
        }

        public Criteria andMemberPointsIsNotNull() {
            addCriterion("MEMBER_POINTS is not null");
            return (Criteria) this;
        }

        public Criteria andMemberPointsEqualTo(Long value) {
            addCriterion("MEMBER_POINTS =", value, "memberPoints");
            return (Criteria) this;
        }

        public Criteria andMemberPointsNotEqualTo(Long value) {
            addCriterion("MEMBER_POINTS <>", value, "memberPoints");
            return (Criteria) this;
        }

        public Criteria andMemberPointsGreaterThan(Long value) {
            addCriterion("MEMBER_POINTS >", value, "memberPoints");
            return (Criteria) this;
        }

        public Criteria andMemberPointsGreaterThanOrEqualTo(Long value) {
            addCriterion("MEMBER_POINTS >=", value, "memberPoints");
            return (Criteria) this;
        }

        public Criteria andMemberPointsLessThan(Long value) {
            addCriterion("MEMBER_POINTS <", value, "memberPoints");
            return (Criteria) this;
        }

        public Criteria andMemberPointsLessThanOrEqualTo(Long value) {
            addCriterion("MEMBER_POINTS <=", value, "memberPoints");
            return (Criteria) this;
        }

        public Criteria andMemberPointsIn(List<Long> values) {
            addCriterion("MEMBER_POINTS in", values, "memberPoints");
            return (Criteria) this;
        }

        public Criteria andMemberPointsNotIn(List<Long> values) {
            addCriterion("MEMBER_POINTS not in", values, "memberPoints");
            return (Criteria) this;
        }

        public Criteria andMemberPointsBetween(Long value1, Long value2) {
            addCriterion("MEMBER_POINTS between", value1, value2, "memberPoints");
            return (Criteria) this;
        }

        public Criteria andMemberPointsNotBetween(Long value1, Long value2) {
            addCriterion("MEMBER_POINTS not between", value1, value2, "memberPoints");
            return (Criteria) this;
        }

        public Criteria andPayPwdIsNull() {
            addCriterion("PAY_PWD is null");
            return (Criteria) this;
        }

        public Criteria andPayPwdIsNotNull() {
            addCriterion("PAY_PWD is not null");
            return (Criteria) this;
        }

        public Criteria andPayPwdEqualTo(String value) {
            addCriterion("PAY_PWD =", value, "payPwd");
            return (Criteria) this;
        }

        public Criteria andPayPwdNotEqualTo(String value) {
            addCriterion("PAY_PWD <>", value, "payPwd");
            return (Criteria) this;
        }

        public Criteria andPayPwdGreaterThan(String value) {
            addCriterion("PAY_PWD >", value, "payPwd");
            return (Criteria) this;
        }

        public Criteria andPayPwdGreaterThanOrEqualTo(String value) {
            addCriterion("PAY_PWD >=", value, "payPwd");
            return (Criteria) this;
        }

        public Criteria andPayPwdLessThan(String value) {
            addCriterion("PAY_PWD <", value, "payPwd");
            return (Criteria) this;
        }

        public Criteria andPayPwdLessThanOrEqualTo(String value) {
            addCriterion("PAY_PWD <=", value, "payPwd");
            return (Criteria) this;
        }

        public Criteria andPayPwdLike(String value) {
            addCriterion("PAY_PWD like", value, "payPwd");
            return (Criteria) this;
        }

        public Criteria andPayPwdNotLike(String value) {
            addCriterion("PAY_PWD not like", value, "payPwd");
            return (Criteria) this;
        }

        public Criteria andPayPwdIn(List<String> values) {
            addCriterion("PAY_PWD in", values, "payPwd");
            return (Criteria) this;
        }

        public Criteria andPayPwdNotIn(List<String> values) {
            addCriterion("PAY_PWD not in", values, "payPwd");
            return (Criteria) this;
        }

        public Criteria andPayPwdBetween(String value1, String value2) {
            addCriterion("PAY_PWD between", value1, value2, "payPwd");
            return (Criteria) this;
        }

        public Criteria andPayPwdNotBetween(String value1, String value2) {
            addCriterion("PAY_PWD not between", value1, value2, "payPwd");
            return (Criteria) this;
        }

        public Criteria andRegisterDateIsNull() {
            addCriterion("REGISTER_DATE is null");
            return (Criteria) this;
        }

        public Criteria andRegisterDateIsNotNull() {
            addCriterion("REGISTER_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andRegisterDateEqualTo(String value) {
            addCriterion("REGISTER_DATE =", value, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateNotEqualTo(String value) {
            addCriterion("REGISTER_DATE <>", value, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateGreaterThan(String value) {
            addCriterion("REGISTER_DATE >", value, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateGreaterThanOrEqualTo(String value) {
            addCriterion("REGISTER_DATE >=", value, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateLessThan(String value) {
            addCriterion("REGISTER_DATE <", value, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateLessThanOrEqualTo(String value) {
            addCriterion("REGISTER_DATE <=", value, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateLike(String value) {
            addCriterion("REGISTER_DATE like", value, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateNotLike(String value) {
            addCriterion("REGISTER_DATE not like", value, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateIn(List<String> values) {
            addCriterion("REGISTER_DATE in", values, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateNotIn(List<String> values) {
            addCriterion("REGISTER_DATE not in", values, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateBetween(String value1, String value2) {
            addCriterion("REGISTER_DATE between", value1, value2, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateNotBetween(String value1, String value2) {
            addCriterion("REGISTER_DATE not between", value1, value2, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterTimeIsNull() {
            addCriterion("REGISTER_TIME is null");
            return (Criteria) this;
        }

        public Criteria andRegisterTimeIsNotNull() {
            addCriterion("REGISTER_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andRegisterTimeEqualTo(String value) {
            addCriterion("REGISTER_TIME =", value, "registerTime");
            return (Criteria) this;
        }

        public Criteria andRegisterTimeNotEqualTo(String value) {
            addCriterion("REGISTER_TIME <>", value, "registerTime");
            return (Criteria) this;
        }

        public Criteria andRegisterTimeGreaterThan(String value) {
            addCriterion("REGISTER_TIME >", value, "registerTime");
            return (Criteria) this;
        }

        public Criteria andRegisterTimeGreaterThanOrEqualTo(String value) {
            addCriterion("REGISTER_TIME >=", value, "registerTime");
            return (Criteria) this;
        }

        public Criteria andRegisterTimeLessThan(String value) {
            addCriterion("REGISTER_TIME <", value, "registerTime");
            return (Criteria) this;
        }

        public Criteria andRegisterTimeLessThanOrEqualTo(String value) {
            addCriterion("REGISTER_TIME <=", value, "registerTime");
            return (Criteria) this;
        }

        public Criteria andRegisterTimeLike(String value) {
            addCriterion("REGISTER_TIME like", value, "registerTime");
            return (Criteria) this;
        }

        public Criteria andRegisterTimeNotLike(String value) {
            addCriterion("REGISTER_TIME not like", value, "registerTime");
            return (Criteria) this;
        }

        public Criteria andRegisterTimeIn(List<String> values) {
            addCriterion("REGISTER_TIME in", values, "registerTime");
            return (Criteria) this;
        }

        public Criteria andRegisterTimeNotIn(List<String> values) {
            addCriterion("REGISTER_TIME not in", values, "registerTime");
            return (Criteria) this;
        }

        public Criteria andRegisterTimeBetween(String value1, String value2) {
            addCriterion("REGISTER_TIME between", value1, value2, "registerTime");
            return (Criteria) this;
        }

        public Criteria andRegisterTimeNotBetween(String value1, String value2) {
            addCriterion("REGISTER_TIME not between", value1, value2, "registerTime");
            return (Criteria) this;
        }

        public Criteria andRegisterFromWayIsNull() {
            addCriterion("REGISTER_FROM_WAY is null");
            return (Criteria) this;
        }

        public Criteria andRegisterFromWayIsNotNull() {
            addCriterion("REGISTER_FROM_WAY is not null");
            return (Criteria) this;
        }

        public Criteria andRegisterFromWayEqualTo(Long value) {
            addCriterion("REGISTER_FROM_WAY =", value, "registerFromWay");
            return (Criteria) this;
        }

        public Criteria andRegisterFromWayNotEqualTo(Long value) {
            addCriterion("REGISTER_FROM_WAY <>", value, "registerFromWay");
            return (Criteria) this;
        }

        public Criteria andRegisterFromWayGreaterThan(Long value) {
            addCriterion("REGISTER_FROM_WAY >", value, "registerFromWay");
            return (Criteria) this;
        }

        public Criteria andRegisterFromWayGreaterThanOrEqualTo(Long value) {
            addCriterion("REGISTER_FROM_WAY >=", value, "registerFromWay");
            return (Criteria) this;
        }

        public Criteria andRegisterFromWayLessThan(Long value) {
            addCriterion("REGISTER_FROM_WAY <", value, "registerFromWay");
            return (Criteria) this;
        }

        public Criteria andRegisterFromWayLessThanOrEqualTo(Long value) {
            addCriterion("REGISTER_FROM_WAY <=", value, "registerFromWay");
            return (Criteria) this;
        }

        public Criteria andRegisterFromWayIn(List<Long> values) {
            addCriterion("REGISTER_FROM_WAY in", values, "registerFromWay");
            return (Criteria) this;
        }

        public Criteria andRegisterFromWayNotIn(List<Long> values) {
            addCriterion("REGISTER_FROM_WAY not in", values, "registerFromWay");
            return (Criteria) this;
        }

        public Criteria andRegisterFromWayBetween(Long value1, Long value2) {
            addCriterion("REGISTER_FROM_WAY between", value1, value2, "registerFromWay");
            return (Criteria) this;
        }

        public Criteria andRegisterFromWayNotBetween(Long value1, Long value2) {
            addCriterion("REGISTER_FROM_WAY not between", value1, value2, "registerFromWay");
            return (Criteria) this;
        }

        public Criteria andRefereeMemberIdIsNull() {
            addCriterion("REFEREE_MEMBER_ID is null");
            return (Criteria) this;
        }

        public Criteria andRefereeMemberIdIsNotNull() {
            addCriterion("REFEREE_MEMBER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andRefereeMemberIdEqualTo(String value) {
            addCriterion("REFEREE_MEMBER_ID =", value, "refereeMemberId");
            return (Criteria) this;
        }

        public Criteria andRefereeMemberIdNotEqualTo(String value) {
            addCriterion("REFEREE_MEMBER_ID <>", value, "refereeMemberId");
            return (Criteria) this;
        }

        public Criteria andRefereeMemberIdGreaterThan(String value) {
            addCriterion("REFEREE_MEMBER_ID >", value, "refereeMemberId");
            return (Criteria) this;
        }

        public Criteria andRefereeMemberIdGreaterThanOrEqualTo(String value) {
            addCriterion("REFEREE_MEMBER_ID >=", value, "refereeMemberId");
            return (Criteria) this;
        }

        public Criteria andRefereeMemberIdLessThan(String value) {
            addCriterion("REFEREE_MEMBER_ID <", value, "refereeMemberId");
            return (Criteria) this;
        }

        public Criteria andRefereeMemberIdLessThanOrEqualTo(String value) {
            addCriterion("REFEREE_MEMBER_ID <=", value, "refereeMemberId");
            return (Criteria) this;
        }

        public Criteria andRefereeMemberIdLike(String value) {
            addCriterion("REFEREE_MEMBER_ID like", value, "refereeMemberId");
            return (Criteria) this;
        }

        public Criteria andRefereeMemberIdNotLike(String value) {
            addCriterion("REFEREE_MEMBER_ID not like", value, "refereeMemberId");
            return (Criteria) this;
        }

        public Criteria andRefereeMemberIdIn(List<String> values) {
            addCriterion("REFEREE_MEMBER_ID in", values, "refereeMemberId");
            return (Criteria) this;
        }

        public Criteria andRefereeMemberIdNotIn(List<String> values) {
            addCriterion("REFEREE_MEMBER_ID not in", values, "refereeMemberId");
            return (Criteria) this;
        }

        public Criteria andRefereeMemberIdBetween(String value1, String value2) {
            addCriterion("REFEREE_MEMBER_ID between", value1, value2, "refereeMemberId");
            return (Criteria) this;
        }

        public Criteria andRefereeMemberIdNotBetween(String value1, String value2) {
            addCriterion("REFEREE_MEMBER_ID not between", value1, value2, "refereeMemberId");
            return (Criteria) this;
        }

        public Criteria andMemberStatusIsNull() {
            addCriterion("MEMBER_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andMemberStatusIsNotNull() {
            addCriterion("MEMBER_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andMemberStatusEqualTo(String value) {
            addCriterion("MEMBER_STATUS =", value, "memberStatus");
            return (Criteria) this;
        }

        public Criteria andMemberStatusNotEqualTo(String value) {
            addCriterion("MEMBER_STATUS <>", value, "memberStatus");
            return (Criteria) this;
        }

        public Criteria andMemberStatusGreaterThan(String value) {
            addCriterion("MEMBER_STATUS >", value, "memberStatus");
            return (Criteria) this;
        }

        public Criteria andMemberStatusGreaterThanOrEqualTo(String value) {
            addCriterion("MEMBER_STATUS >=", value, "memberStatus");
            return (Criteria) this;
        }

        public Criteria andMemberStatusLessThan(String value) {
            addCriterion("MEMBER_STATUS <", value, "memberStatus");
            return (Criteria) this;
        }

        public Criteria andMemberStatusLessThanOrEqualTo(String value) {
            addCriterion("MEMBER_STATUS <=", value, "memberStatus");
            return (Criteria) this;
        }

        public Criteria andMemberStatusLike(String value) {
            addCriterion("MEMBER_STATUS like", value, "memberStatus");
            return (Criteria) this;
        }

        public Criteria andMemberStatusNotLike(String value) {
            addCriterion("MEMBER_STATUS not like", value, "memberStatus");
            return (Criteria) this;
        }

        public Criteria andMemberStatusIn(List<String> values) {
            addCriterion("MEMBER_STATUS in", values, "memberStatus");
            return (Criteria) this;
        }

        public Criteria andMemberStatusNotIn(List<String> values) {
            addCriterion("MEMBER_STATUS not in", values, "memberStatus");
            return (Criteria) this;
        }

        public Criteria andMemberStatusBetween(String value1, String value2) {
            addCriterion("MEMBER_STATUS between", value1, value2, "memberStatus");
            return (Criteria) this;
        }

        public Criteria andMemberStatusNotBetween(String value1, String value2) {
            addCriterion("MEMBER_STATUS not between", value1, value2, "memberStatus");
            return (Criteria) this;
        }

        public Criteria andMemberTypeIsNull() {
            addCriterion("MEMBER_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andMemberTypeIsNotNull() {
            addCriterion("MEMBER_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andMemberTypeEqualTo(String value) {
            addCriterion("MEMBER_TYPE =", value, "memberType");
            return (Criteria) this;
        }

        public Criteria andMemberTypeNotEqualTo(String value) {
            addCriterion("MEMBER_TYPE <>", value, "memberType");
            return (Criteria) this;
        }

        public Criteria andMemberTypeGreaterThan(String value) {
            addCriterion("MEMBER_TYPE >", value, "memberType");
            return (Criteria) this;
        }

        public Criteria andMemberTypeGreaterThanOrEqualTo(String value) {
            addCriterion("MEMBER_TYPE >=", value, "memberType");
            return (Criteria) this;
        }

        public Criteria andMemberTypeLessThan(String value) {
            addCriterion("MEMBER_TYPE <", value, "memberType");
            return (Criteria) this;
        }

        public Criteria andMemberTypeLessThanOrEqualTo(String value) {
            addCriterion("MEMBER_TYPE <=", value, "memberType");
            return (Criteria) this;
        }

        public Criteria andMemberTypeLike(String value) {
            addCriterion("MEMBER_TYPE like", value, "memberType");
            return (Criteria) this;
        }

        public Criteria andMemberTypeNotLike(String value) {
            addCriterion("MEMBER_TYPE not like", value, "memberType");
            return (Criteria) this;
        }

        public Criteria andMemberTypeIn(List<String> values) {
            addCriterion("MEMBER_TYPE in", values, "memberType");
            return (Criteria) this;
        }

        public Criteria andMemberTypeNotIn(List<String> values) {
            addCriterion("MEMBER_TYPE not in", values, "memberType");
            return (Criteria) this;
        }

        public Criteria andMemberTypeBetween(String value1, String value2) {
            addCriterion("MEMBER_TYPE between", value1, value2, "memberType");
            return (Criteria) this;
        }

        public Criteria andMemberTypeNotBetween(String value1, String value2) {
            addCriterion("MEMBER_TYPE not between", value1, value2, "memberType");
            return (Criteria) this;
        }

        public Criteria andMemberLevelIsNull() {
            addCriterion("MEMBER_LEVEL is null");
            return (Criteria) this;
        }

        public Criteria andMemberLevelIsNotNull() {
            addCriterion("MEMBER_LEVEL is not null");
            return (Criteria) this;
        }

        public Criteria andMemberLevelEqualTo(String value) {
            addCriterion("MEMBER_LEVEL =", value, "memberLevel");
            return (Criteria) this;
        }

        public Criteria andMemberLevelNotEqualTo(String value) {
            addCriterion("MEMBER_LEVEL <>", value, "memberLevel");
            return (Criteria) this;
        }

        public Criteria andMemberLevelGreaterThan(String value) {
            addCriterion("MEMBER_LEVEL >", value, "memberLevel");
            return (Criteria) this;
        }

        public Criteria andMemberLevelGreaterThanOrEqualTo(String value) {
            addCriterion("MEMBER_LEVEL >=", value, "memberLevel");
            return (Criteria) this;
        }

        public Criteria andMemberLevelLessThan(String value) {
            addCriterion("MEMBER_LEVEL <", value, "memberLevel");
            return (Criteria) this;
        }

        public Criteria andMemberLevelLessThanOrEqualTo(String value) {
            addCriterion("MEMBER_LEVEL <=", value, "memberLevel");
            return (Criteria) this;
        }

        public Criteria andMemberLevelLike(String value) {
            addCriterion("MEMBER_LEVEL like", value, "memberLevel");
            return (Criteria) this;
        }

        public Criteria andMemberLevelNotLike(String value) {
            addCriterion("MEMBER_LEVEL not like", value, "memberLevel");
            return (Criteria) this;
        }

        public Criteria andMemberLevelIn(List<String> values) {
            addCriterion("MEMBER_LEVEL in", values, "memberLevel");
            return (Criteria) this;
        }

        public Criteria andMemberLevelNotIn(List<String> values) {
            addCriterion("MEMBER_LEVEL not in", values, "memberLevel");
            return (Criteria) this;
        }

        public Criteria andMemberLevelBetween(String value1, String value2) {
            addCriterion("MEMBER_LEVEL between", value1, value2, "memberLevel");
            return (Criteria) this;
        }

        public Criteria andMemberLevelNotBetween(String value1, String value2) {
            addCriterion("MEMBER_LEVEL not between", value1, value2, "memberLevel");
            return (Criteria) this;
        }

        public Criteria andMemberExpIsNull() {
            addCriterion("MEMBER_EXP is null");
            return (Criteria) this;
        }

        public Criteria andMemberExpIsNotNull() {
            addCriterion("MEMBER_EXP is not null");
            return (Criteria) this;
        }

        public Criteria andMemberExpEqualTo(Long value) {
            addCriterion("MEMBER_EXP =", value, "memberExp");
            return (Criteria) this;
        }

        public Criteria andMemberExpNotEqualTo(Long value) {
            addCriterion("MEMBER_EXP <>", value, "memberExp");
            return (Criteria) this;
        }

        public Criteria andMemberExpGreaterThan(Long value) {
            addCriterion("MEMBER_EXP >", value, "memberExp");
            return (Criteria) this;
        }

        public Criteria andMemberExpGreaterThanOrEqualTo(Long value) {
            addCriterion("MEMBER_EXP >=", value, "memberExp");
            return (Criteria) this;
        }

        public Criteria andMemberExpLessThan(Long value) {
            addCriterion("MEMBER_EXP <", value, "memberExp");
            return (Criteria) this;
        }

        public Criteria andMemberExpLessThanOrEqualTo(Long value) {
            addCriterion("MEMBER_EXP <=", value, "memberExp");
            return (Criteria) this;
        }

        public Criteria andMemberExpIn(List<Long> values) {
            addCriterion("MEMBER_EXP in", values, "memberExp");
            return (Criteria) this;
        }

        public Criteria andMemberExpNotIn(List<Long> values) {
            addCriterion("MEMBER_EXP not in", values, "memberExp");
            return (Criteria) this;
        }

        public Criteria andMemberExpBetween(Long value1, Long value2) {
            addCriterion("MEMBER_EXP between", value1, value2, "memberExp");
            return (Criteria) this;
        }

        public Criteria andMemberExpNotBetween(Long value1, Long value2) {
            addCriterion("MEMBER_EXP not between", value1, value2, "memberExp");
            return (Criteria) this;
        }

        public Criteria andInsertDateIsNull() {
            addCriterion("INSERT_DATE is null");
            return (Criteria) this;
        }

        public Criteria andInsertDateIsNotNull() {
            addCriterion("INSERT_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andInsertDateEqualTo(String value) {
            addCriterion("INSERT_DATE =", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateNotEqualTo(String value) {
            addCriterion("INSERT_DATE <>", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateGreaterThan(String value) {
            addCriterion("INSERT_DATE >", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateGreaterThanOrEqualTo(String value) {
            addCriterion("INSERT_DATE >=", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateLessThan(String value) {
            addCriterion("INSERT_DATE <", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateLessThanOrEqualTo(String value) {
            addCriterion("INSERT_DATE <=", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateLike(String value) {
            addCriterion("INSERT_DATE like", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateNotLike(String value) {
            addCriterion("INSERT_DATE not like", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateIn(List<String> values) {
            addCriterion("INSERT_DATE in", values, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateNotIn(List<String> values) {
            addCriterion("INSERT_DATE not in", values, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateBetween(String value1, String value2) {
            addCriterion("INSERT_DATE between", value1, value2, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateNotBetween(String value1, String value2) {
            addCriterion("INSERT_DATE not between", value1, value2, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertTimeIsNull() {
            addCriterion("INSERT_TIME is null");
            return (Criteria) this;
        }

        public Criteria andInsertTimeIsNotNull() {
            addCriterion("INSERT_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andInsertTimeEqualTo(String value) {
            addCriterion("INSERT_TIME =", value, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeNotEqualTo(String value) {
            addCriterion("INSERT_TIME <>", value, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeGreaterThan(String value) {
            addCriterion("INSERT_TIME >", value, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeGreaterThanOrEqualTo(String value) {
            addCriterion("INSERT_TIME >=", value, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeLessThan(String value) {
            addCriterion("INSERT_TIME <", value, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeLessThanOrEqualTo(String value) {
            addCriterion("INSERT_TIME <=", value, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeLike(String value) {
            addCriterion("INSERT_TIME like", value, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeNotLike(String value) {
            addCriterion("INSERT_TIME not like", value, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeIn(List<String> values) {
            addCriterion("INSERT_TIME in", values, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeNotIn(List<String> values) {
            addCriterion("INSERT_TIME not in", values, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeBetween(String value1, String value2) {
            addCriterion("INSERT_TIME between", value1, value2, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeNotBetween(String value1, String value2) {
            addCriterion("INSERT_TIME not between", value1, value2, "insertTime");
            return (Criteria) this;
        }

        public Criteria andLockStatusIsNull() {
            addCriterion("LOCK_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andLockStatusIsNotNull() {
            addCriterion("LOCK_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andLockStatusEqualTo(String value) {
            addCriterion("LOCK_STATUS =", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusNotEqualTo(String value) {
            addCriterion("LOCK_STATUS <>", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusGreaterThan(String value) {
            addCriterion("LOCK_STATUS >", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusGreaterThanOrEqualTo(String value) {
            addCriterion("LOCK_STATUS >=", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusLessThan(String value) {
            addCriterion("LOCK_STATUS <", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusLessThanOrEqualTo(String value) {
            addCriterion("LOCK_STATUS <=", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusLike(String value) {
            addCriterion("LOCK_STATUS like", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusNotLike(String value) {
            addCriterion("LOCK_STATUS not like", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusIn(List<String> values) {
            addCriterion("LOCK_STATUS in", values, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusNotIn(List<String> values) {
            addCriterion("LOCK_STATUS not in", values, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusBetween(String value1, String value2) {
            addCriterion("LOCK_STATUS between", value1, value2, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusNotBetween(String value1, String value2) {
            addCriterion("LOCK_STATUS not between", value1, value2, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andErrorNumIsNull() {
            addCriterion("ERROR_NUM is null");
            return (Criteria) this;
        }

        public Criteria andErrorNumIsNotNull() {
            addCriterion("ERROR_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andErrorNumEqualTo(Short value) {
            addCriterion("ERROR_NUM =", value, "errorNum");
            return (Criteria) this;
        }

        public Criteria andErrorNumNotEqualTo(Short value) {
            addCriterion("ERROR_NUM <>", value, "errorNum");
            return (Criteria) this;
        }

        public Criteria andErrorNumGreaterThan(Short value) {
            addCriterion("ERROR_NUM >", value, "errorNum");
            return (Criteria) this;
        }

        public Criteria andErrorNumGreaterThanOrEqualTo(Short value) {
            addCriterion("ERROR_NUM >=", value, "errorNum");
            return (Criteria) this;
        }

        public Criteria andErrorNumLessThan(Short value) {
            addCriterion("ERROR_NUM <", value, "errorNum");
            return (Criteria) this;
        }

        public Criteria andErrorNumLessThanOrEqualTo(Short value) {
            addCriterion("ERROR_NUM <=", value, "errorNum");
            return (Criteria) this;
        }

        public Criteria andErrorNumIn(List<Short> values) {
            addCriterion("ERROR_NUM in", values, "errorNum");
            return (Criteria) this;
        }

        public Criteria andErrorNumNotIn(List<Short> values) {
            addCriterion("ERROR_NUM not in", values, "errorNum");
            return (Criteria) this;
        }

        public Criteria andErrorNumBetween(Short value1, Short value2) {
            addCriterion("ERROR_NUM between", value1, value2, "errorNum");
            return (Criteria) this;
        }

        public Criteria andErrorNumNotBetween(Short value1, Short value2) {
            addCriterion("ERROR_NUM not between", value1, value2, "errorNum");
            return (Criteria) this;
        }

        public Criteria andErrorNumTotalIsNull() {
            addCriterion("ERROR_NUM_TOTAL is null");
            return (Criteria) this;
        }

        public Criteria andErrorNumTotalIsNotNull() {
            addCriterion("ERROR_NUM_TOTAL is not null");
            return (Criteria) this;
        }

        public Criteria andErrorNumTotalEqualTo(Long value) {
            addCriterion("ERROR_NUM_TOTAL =", value, "errorNumTotal");
            return (Criteria) this;
        }

        public Criteria andErrorNumTotalNotEqualTo(Long value) {
            addCriterion("ERROR_NUM_TOTAL <>", value, "errorNumTotal");
            return (Criteria) this;
        }

        public Criteria andErrorNumTotalGreaterThan(Long value) {
            addCriterion("ERROR_NUM_TOTAL >", value, "errorNumTotal");
            return (Criteria) this;
        }

        public Criteria andErrorNumTotalGreaterThanOrEqualTo(Long value) {
            addCriterion("ERROR_NUM_TOTAL >=", value, "errorNumTotal");
            return (Criteria) this;
        }

        public Criteria andErrorNumTotalLessThan(Long value) {
            addCriterion("ERROR_NUM_TOTAL <", value, "errorNumTotal");
            return (Criteria) this;
        }

        public Criteria andErrorNumTotalLessThanOrEqualTo(Long value) {
            addCriterion("ERROR_NUM_TOTAL <=", value, "errorNumTotal");
            return (Criteria) this;
        }

        public Criteria andErrorNumTotalIn(List<Long> values) {
            addCriterion("ERROR_NUM_TOTAL in", values, "errorNumTotal");
            return (Criteria) this;
        }

        public Criteria andErrorNumTotalNotIn(List<Long> values) {
            addCriterion("ERROR_NUM_TOTAL not in", values, "errorNumTotal");
            return (Criteria) this;
        }

        public Criteria andErrorNumTotalBetween(Long value1, Long value2) {
            addCriterion("ERROR_NUM_TOTAL between", value1, value2, "errorNumTotal");
            return (Criteria) this;
        }

        public Criteria andErrorNumTotalNotBetween(Long value1, Long value2) {
            addCriterion("ERROR_NUM_TOTAL not between", value1, value2, "errorNumTotal");
            return (Criteria) this;
        }

        public Criteria andMemberNameIsNull() {
            addCriterion("MEMBER_NAME is null");
            return (Criteria) this;
        }

        public Criteria andMemberNameIsNotNull() {
            addCriterion("MEMBER_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andMemberNameEqualTo(String value) {
            addCriterion("MEMBER_NAME =", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameNotEqualTo(String value) {
            addCriterion("MEMBER_NAME <>", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameGreaterThan(String value) {
            addCriterion("MEMBER_NAME >", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameGreaterThanOrEqualTo(String value) {
            addCriterion("MEMBER_NAME >=", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameLessThan(String value) {
            addCriterion("MEMBER_NAME <", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameLessThanOrEqualTo(String value) {
            addCriterion("MEMBER_NAME <=", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameLike(String value) {
            addCriterion("MEMBER_NAME like", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameNotLike(String value) {
            addCriterion("MEMBER_NAME not like", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameIn(List<String> values) {
            addCriterion("MEMBER_NAME in", values, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameNotIn(List<String> values) {
            addCriterion("MEMBER_NAME not in", values, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameBetween(String value1, String value2) {
            addCriterion("MEMBER_NAME between", value1, value2, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameNotBetween(String value1, String value2) {
            addCriterion("MEMBER_NAME not between", value1, value2, "memberName");
            return (Criteria) this;
        }

        public Criteria andIsPlatformIsNull() {
            addCriterion("IS_PLATFORM is null");
            return (Criteria) this;
        }

        public Criteria andIsPlatformIsNotNull() {
            addCriterion("IS_PLATFORM is not null");
            return (Criteria) this;
        }

        public Criteria andIsPlatformEqualTo(Long value) {
            addCriterion("IS_PLATFORM =", value, "isPlatform");
            return (Criteria) this;
        }

        public Criteria andIsPlatformNotEqualTo(Long value) {
            addCriterion("IS_PLATFORM <>", value, "isPlatform");
            return (Criteria) this;
        }

        public Criteria andIsPlatformGreaterThan(Long value) {
            addCriterion("IS_PLATFORM >", value, "isPlatform");
            return (Criteria) this;
        }

        public Criteria andIsPlatformGreaterThanOrEqualTo(Long value) {
            addCriterion("IS_PLATFORM >=", value, "isPlatform");
            return (Criteria) this;
        }

        public Criteria andIsPlatformLessThan(Long value) {
            addCriterion("IS_PLATFORM <", value, "isPlatform");
            return (Criteria) this;
        }

        public Criteria andIsPlatformLessThanOrEqualTo(Long value) {
            addCriterion("IS_PLATFORM <=", value, "isPlatform");
            return (Criteria) this;
        }

        public Criteria andIsPlatformIn(List<Long> values) {
            addCriterion("IS_PLATFORM in", values, "isPlatform");
            return (Criteria) this;
        }

        public Criteria andIsPlatformNotIn(List<Long> values) {
            addCriterion("IS_PLATFORM not in", values, "isPlatform");
            return (Criteria) this;
        }

        public Criteria andIsPlatformBetween(Long value1, Long value2) {
            addCriterion("IS_PLATFORM between", value1, value2, "isPlatform");
            return (Criteria) this;
        }

        public Criteria andIsPlatformNotBetween(Long value1, Long value2) {
            addCriterion("IS_PLATFORM not between", value1, value2, "isPlatform");
            return (Criteria) this;
        }

        public Criteria andOpenFlagIsNull() {
            addCriterion("OPEN_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andOpenFlagIsNotNull() {
            addCriterion("OPEN_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andOpenFlagEqualTo(Short value) {
            addCriterion("OPEN_FLAG =", value, "openFlag");
            return (Criteria) this;
        }

        public Criteria andOpenFlagNotEqualTo(Short value) {
            addCriterion("OPEN_FLAG <>", value, "openFlag");
            return (Criteria) this;
        }

        public Criteria andOpenFlagGreaterThan(Short value) {
            addCriterion("OPEN_FLAG >", value, "openFlag");
            return (Criteria) this;
        }

        public Criteria andOpenFlagGreaterThanOrEqualTo(Short value) {
            addCriterion("OPEN_FLAG >=", value, "openFlag");
            return (Criteria) this;
        }

        public Criteria andOpenFlagLessThan(Short value) {
            addCriterion("OPEN_FLAG <", value, "openFlag");
            return (Criteria) this;
        }

        public Criteria andOpenFlagLessThanOrEqualTo(Short value) {
            addCriterion("OPEN_FLAG <=", value, "openFlag");
            return (Criteria) this;
        }

        public Criteria andOpenFlagIn(List<Short> values) {
            addCriterion("OPEN_FLAG in", values, "openFlag");
            return (Criteria) this;
        }

        public Criteria andOpenFlagNotIn(List<Short> values) {
            addCriterion("OPEN_FLAG not in", values, "openFlag");
            return (Criteria) this;
        }

        public Criteria andOpenFlagBetween(Short value1, Short value2) {
            addCriterion("OPEN_FLAG between", value1, value2, "openFlag");
            return (Criteria) this;
        }

        public Criteria andOpenFlagNotBetween(Short value1, Short value2) {
            addCriterion("OPEN_FLAG not between", value1, value2, "openFlag");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinTotalIsNull() {
            addCriterion("VIRTUAL_COIN_TOTAL is null");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinTotalIsNotNull() {
            addCriterion("VIRTUAL_COIN_TOTAL is not null");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinTotalEqualTo(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_TOTAL =", value, "virtualCoinTotal");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinTotalNotEqualTo(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_TOTAL <>", value, "virtualCoinTotal");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinTotalGreaterThan(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_TOTAL >", value, "virtualCoinTotal");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinTotalGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_TOTAL >=", value, "virtualCoinTotal");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinTotalLessThan(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_TOTAL <", value, "virtualCoinTotal");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinTotalLessThanOrEqualTo(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_TOTAL <=", value, "virtualCoinTotal");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinTotalIn(List<BigDecimal> values) {
            addCriterion("VIRTUAL_COIN_TOTAL in", values, "virtualCoinTotal");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinTotalNotIn(List<BigDecimal> values) {
            addCriterion("VIRTUAL_COIN_TOTAL not in", values, "virtualCoinTotal");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinTotalBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VIRTUAL_COIN_TOTAL between", value1, value2, "virtualCoinTotal");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinTotalNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VIRTUAL_COIN_TOTAL not between", value1, value2, "virtualCoinTotal");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinAvaliableIsNull() {
            addCriterion("VIRTUAL_COIN_AVALIABLE is null");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinAvaliableIsNotNull() {
            addCriterion("VIRTUAL_COIN_AVALIABLE is not null");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinAvaliableEqualTo(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_AVALIABLE =", value, "virtualCoinAvaliable");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinAvaliableNotEqualTo(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_AVALIABLE <>", value, "virtualCoinAvaliable");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinAvaliableGreaterThan(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_AVALIABLE >", value, "virtualCoinAvaliable");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinAvaliableGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_AVALIABLE >=", value, "virtualCoinAvaliable");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinAvaliableLessThan(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_AVALIABLE <", value, "virtualCoinAvaliable");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinAvaliableLessThanOrEqualTo(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_AVALIABLE <=", value, "virtualCoinAvaliable");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinAvaliableIn(List<BigDecimal> values) {
            addCriterion("VIRTUAL_COIN_AVALIABLE in", values, "virtualCoinAvaliable");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinAvaliableNotIn(List<BigDecimal> values) {
            addCriterion("VIRTUAL_COIN_AVALIABLE not in", values, "virtualCoinAvaliable");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinAvaliableBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VIRTUAL_COIN_AVALIABLE between", value1, value2, "virtualCoinAvaliable");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinAvaliableNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VIRTUAL_COIN_AVALIABLE not between", value1, value2, "virtualCoinAvaliable");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinWithdrawIsNull() {
            addCriterion("VIRTUAL_COIN_WITHDRAW is null");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinWithdrawIsNotNull() {
            addCriterion("VIRTUAL_COIN_WITHDRAW is not null");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinWithdrawEqualTo(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_WITHDRAW =", value, "virtualCoinWithdraw");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinWithdrawNotEqualTo(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_WITHDRAW <>", value, "virtualCoinWithdraw");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinWithdrawGreaterThan(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_WITHDRAW >", value, "virtualCoinWithdraw");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinWithdrawGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_WITHDRAW >=", value, "virtualCoinWithdraw");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinWithdrawLessThan(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_WITHDRAW <", value, "virtualCoinWithdraw");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinWithdrawLessThanOrEqualTo(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_WITHDRAW <=", value, "virtualCoinWithdraw");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinWithdrawIn(List<BigDecimal> values) {
            addCriterion("VIRTUAL_COIN_WITHDRAW in", values, "virtualCoinWithdraw");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinWithdrawNotIn(List<BigDecimal> values) {
            addCriterion("VIRTUAL_COIN_WITHDRAW not in", values, "virtualCoinWithdraw");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinWithdrawBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VIRTUAL_COIN_WITHDRAW between", value1, value2, "virtualCoinWithdraw");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinWithdrawNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VIRTUAL_COIN_WITHDRAW not between", value1, value2, "virtualCoinWithdraw");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinFrozenIsNull() {
            addCriterion("VIRTUAL_COIN_FROZEN is null");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinFrozenIsNotNull() {
            addCriterion("VIRTUAL_COIN_FROZEN is not null");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinFrozenEqualTo(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_FROZEN =", value, "virtualCoinFrozen");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinFrozenNotEqualTo(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_FROZEN <>", value, "virtualCoinFrozen");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinFrozenGreaterThan(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_FROZEN >", value, "virtualCoinFrozen");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinFrozenGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_FROZEN >=", value, "virtualCoinFrozen");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinFrozenLessThan(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_FROZEN <", value, "virtualCoinFrozen");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinFrozenLessThanOrEqualTo(BigDecimal value) {
            addCriterion("VIRTUAL_COIN_FROZEN <=", value, "virtualCoinFrozen");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinFrozenIn(List<BigDecimal> values) {
            addCriterion("VIRTUAL_COIN_FROZEN in", values, "virtualCoinFrozen");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinFrozenNotIn(List<BigDecimal> values) {
            addCriterion("VIRTUAL_COIN_FROZEN not in", values, "virtualCoinFrozen");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinFrozenBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VIRTUAL_COIN_FROZEN between", value1, value2, "virtualCoinFrozen");
            return (Criteria) this;
        }

        public Criteria andVirtualCoinFrozenNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VIRTUAL_COIN_FROZEN not between", value1, value2, "virtualCoinFrozen");
            return (Criteria) this;
        }

        public Criteria andBrokerIdIsNull() {
            addCriterion("BROKER_ID is null");
            return (Criteria) this;
        }

        public Criteria andBrokerIdIsNotNull() {
            addCriterion("BROKER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andBrokerIdEqualTo(String value) {
            addCriterion("BROKER_ID =", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdNotEqualTo(String value) {
            addCriterion("BROKER_ID <>", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdGreaterThan(String value) {
            addCriterion("BROKER_ID >", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdGreaterThanOrEqualTo(String value) {
            addCriterion("BROKER_ID >=", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdLessThan(String value) {
            addCriterion("BROKER_ID <", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdLessThanOrEqualTo(String value) {
            addCriterion("BROKER_ID <=", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdLike(String value) {
            addCriterion("BROKER_ID like", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdNotLike(String value) {
            addCriterion("BROKER_ID not like", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdIn(List<String> values) {
            addCriterion("BROKER_ID in", values, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdNotIn(List<String> values) {
            addCriterion("BROKER_ID not in", values, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdBetween(String value1, String value2) {
            addCriterion("BROKER_ID between", value1, value2, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdNotBetween(String value1, String value2) {
            addCriterion("BROKER_ID not between", value1, value2, "brokerId");
            return (Criteria) this;
        }
    }

    /**
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}